package com.qianyu.project.mapper.provider.smj;

import com.baomidou.mybatisplus.core.metadata.IPage;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.SelectProvider;
import org.springframework.stereotype.Repository;

import java.util.List;
import java.util.Map;

@Repository
public interface smjRealnameDao {
    //查询工种信息
    @Select("select * from profession")
    List<Map<String, Object>> getprofessions();

    //添加实名制信息
    @Insert("insert into realname values(null,#{name},#{sfz},#{profession},#{p_id},#{commit},#{apply_date},#{attach_ids},#{attach_ids2})")
    void AddRealname(String name, String sfz, String profession, String p_id, String commit, String apply_date, String attach_ids, String attach_ids2);

    //获取劳务实名制列表
    @SelectProvider(type = smjRealnameProvider.class ,method = "ListFragmentary")
    IPage<Map<String, Object>> ListFragmentary(IPage<Map<String, Object>> page, Map<String, String> params);
}
